Stored Procedures [dbo].[BAECartEventUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartEventIDint4
@CartItemIDint4
@EventCodevarchar(64)64
@Titlevarchar(128)128
@RegistrantClassvarchar(64)64
@RegistrantIDvarchar(16)16
@Completebit1
SQL Script
create procedure [dbo].[BAECartEventUpdate] @CartEventID as
int,    
    @CartItemID AS int,    
    @EventCode AS varchar(64),    
    @Title AS varchar(128),    
    @RegistrantClass AS varchar(64),    
    @RegistrantID AS varchar(16),    
    @Complete AS bit    
AS
    UPDATE CartEvent
    SET CartItemID = @CartItemID,
        EventCode = @EventCode,
        Title = @Title,
        RegistrantClass = @RegistrantClass,
        RegistrantID = @RegistrantID,
        Complete = @Complete
    WHERE CartEventID = @CartEventID;

GO
Uses